IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'SagaGet')
	BEGIN
		DROP  Procedure  SagaGet
	END

GO

CREATE Procedure SagaGet
	@SagaID int
AS
SELECT 
SagaID,
TemplateStyle,
Name,
TagLine,
Header,
CurrentAffairs,
SagaSummary,
FormationStory,
FoundedMonth,
FoundedYear,
CurrentYear,
DATENAME(month, CONVERT(DATETIME, CONVERT(nvarchar,FoundedMonth) + '/1/2000') ) + ' ' + CONVERT(nvarchar, FoundedYear) + ' A.D.' as FoundedDate
FROM Saga 

WHERE SagaID = @SagaID
